PaymentProcessorAccount

EntityType | Independent
Logical Entity Name | PaymentProcessorAccount
Default Table Name | SyPaymentAccount
Logical Only | NO
Owner | dbo
Definition |
Note |

PaymentProcessorAccount Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
PaymentProcessorAccountId |  | INTEGER | NO |
Code |  | CHAR(8) | NO |
Name |  | VARCHAR(50) | NO |
Partner |  | VARCHAR(50) | NO |
VendorIdentifier |  | VARCHAR(50) | NO |
SchoolUserIdentifier |  | VARCHAR(50) | NO |
SchoolPassword |  | VARCHAR(130) | YES |
TransactionFeeType |  | CHAR(1) | NO |
TransactionFeeAmount |  | NUMERIC(12, 2) | YES |
TransactionFeeMinimum |  | NUMERIC(12, 2) | YES |
TransactionFeeMaximum |  | NUMERIC(12, 2) | YES |
TransactionFeeSource |  | CHAR(1) | YES |
TransactionFeeBillingTransactionCodeId |  | INTEGER | YES |
TransactionMinimum |  | NUMERIC(12, 2) | YES |
TransactionMaximum |  | NUMERIC(12, 2) | YES |
LastModifiedUserId |  | INTEGER | YES |
CreatedDateTime |  | DATETIME | YES |
LastModifiedDateTime |  | DATETIME | YES |
RowVersion |  | TIMESTAMP/DATE | NO |
IsTestMode |  | BIT | NO |
PasswdRandomKey |  | VARCHAR(258) | YES |
InitializationVector |  | VARCHAR(100) | YES |
PaymentProcessorId |  | INTEGER | YES |
AuthorizationAmount |  | MONEY(19, 4) | NO |
BillingTransactionCodeId |  | INTEGER | YES |

PaymentProcessorAccount Keys

Key Name | Key Type | Keys
SyPaymentAccount_SyPaymentAccountID_U_C_IDX | PrimaryKey | PaymentProcessorAccountId
SyPaymentAccount_UserID_N_N_IDX | Inversion Entry | LastModifiedUserId
SyPaymentAccount_TransFeeSaBillCodeID_N_N_IDX | Inversion Entry | TransactionFeeBillingTransactionCodeId
SyPaymentAccount_Code_U_N_IDX | Unique Constraint | Code

PaymentProcessorAccount Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
PaymentProcessor | Non-Identifying | Zero or One to Zero or More |  |  |  | PaymentProcessorId | NO
BillingTransactionCode | Non-Identifying | Zero or One to Zero or More |  |  |  | TransactionFeeBillingTransactionCodeId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | LastModifiedUserId | NO
PaymentProcessor | Non-Identifying | Zero or One to Zero or More |  |  |  | PaymentProcessorId | NO
BillingTransactionCode | Non-Identifying | Zero or One to Zero or More |  |  |  | BillingTransactionCodeId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
Campus | Non-Identifying | One To Zero or More |  |  |  |  | NO
CreditCardBatchFileSetting | Non-Identifying | One To Zero or More |  |  |  |  | NO

PaymentProcessorAccount Check Constraints

Check Constraint Name | CheckConstraint
Chk_SyPaymentAccount_TransFeeNum_Num | ([TransFeeType] = 'P' or [TransFeeNum] >= [TransFeeMin] and [TransFeeNum] <= [TransFeeMax])
Chk_SyPaymentAccount_TransFeeNum_Pct | ([TransFeeType] = 'F' or [TransFeeNum] >= 0 and [TransFeeNum] <= 100)
Chk_SyPaymentAccount_TransMax | ([TransMax] >= [TransMin])
Chk_SyPaymentAccount_TransFeeMax | ([TransFeeMax] >= [TransFeeMin])

PaymentProcessorAccount Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.PaymentProcessorAccount | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyPaymentAccount | NO |  |  |

PaymentProcessorAccount Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ElectronicPaymentProcessing
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

PaymentProcessorAccount Data Movement Rules

Name | Type | Rule Text/Value